﻿CREATE TABLE [dbo].[ez_AttendanceInfo] (
    [AttendanceId] UNIQUEIDENTIFIER NOT NULL,
    [UserId]       UNIQUEIDENTIFIER NOT NULL,
    [Day]          DATE             NOT NULL,
    [DutyType]     INT              NOT NULL,
    [ActionTime]   DATETIME         NOT NULL,
    [Explanation]  NVARCHAR (200)   NULL,
    [IsExtraWork]  BIT              NOT NULL
);









